﻿-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<我的提醒列表>
-- =============================================
CREATE PROCEDURE [dbo].[proc_TimeRemind_MyRemindList]
(
	@UserName VARCHAR(50),
	@TimeType INT
)

AS
BEGIN

IF @TimeType=0
BEGIN
	SELECT * FROM TimeRemind WHERE UserName=@UserName ORDER BY CreateDate DESC
END
ELSE
BEGIN
	SELECT * FROM TimeRemind WHERE UserName=@UserName AND TimeType=@TimeType ORDER BY CreateDate DESC
END

SET NOCOUNT ON;
END